SPOOL $HOME/crst_fm/MISC/log/test_result_po.txt

DEFINE NGO_CODE = '&1'
DEFINE BG_CODE= '&2'
DEFINE NGO_SOB_SHORT_CODE= '&3'

@$HOME/crst_fm/PO/recon/CAPPOREC_APPROVAL_GROUP.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_APPROVAL_GROUP_ASSIGNMENT.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_APPROVAL_PATH.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_APPROVED_SUPPLIER_LIST.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_ATTACHMENT.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_BUYER.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_DOCUMENT_TYPE.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_ITEM.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_JOB.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_LOCATION.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_ORGANIZATION_ACCESS.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_PERSON.sql  &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_PERSON_ASSIGNMENT.sql  &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_POSITION.sql  &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_POSITION_HIERARCHY.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_PURCHASE_OPTION.sql  &NGO_SOB_SHORT_CODE 
@$HOME/crst_fm/PO/recon/CAPPOREC_PURCHASE_ORDER_DISTRIBUTION.sql  &NGO_CODE 
@$HOME/crst_fm/PO/recon/CAPPOREC_PURCHASE_ORDER_HEADER.sql  &NGO_CODE 
@$HOME/crst_fm/PO/recon/CAPPOREC_PURCHASE_ORDER_LINE.sql  &NGO_CODE 
@$HOME/crst_fm/PO/recon/CAPPOREC_PURCHASE_ORDER_LINE_LOCATION.sql  &NGO_CODE 
@$HOME/crst_fm/PO/recon/CAPPOREC_RECEIPT_HEADER.sql  &NGO_CODE 
@$HOME/crst_fm/PO/recon/CAPPOREC_RECEIPT_LINE.sql  &NGO_CODE 
@$HOME/crst_fm/PO/recon/CAPPOREC_RECEIPT_TRANSACTION.sql  &NGO_CODE 
@$HOME/crst_fm/PO/recon/CAPPOREC_RECEIVING_OPTION.sql  &NGO_SOB_SHORT_CODE 
@$HOME/crst_fm/PO/recon/CAPPOREC_REQUISITION_DISTRIBUTION.sql  &NGO_CODE 
@$HOME/crst_fm/PO/recon/CAPPOREC_REQUISITION_HEADER.sql  &NGO_CODE 
@$HOME/crst_fm/PO/recon/CAPPOREC_REQUISITION_LINE.sql  &NGO_CODE 
@$HOME/crst_fm/PO/recon/CAPPOREC_RFQ_VENDOR.sql  &NGO_CODE 
@$HOME/crst_fm/PO/recon/CAPPOREC_SUPPLIER.sql  &NGO_SOB_SHORT_CODE 
@$HOME/crst_fm/PO/recon/CAPPOREC_SUPPLIER_CONTACT.sql  &NGO_SOB_SHORT_CODE 
@$HOME/crst_fm/PO/recon/CAPPOREC_SUPPLIER_LIST.sql &NGO_SOB_SHORT_CODE 
@$HOME/crst_fm/PO/recon/CAPPOREC_SUPPLIER_SITE.sql &NGO_SOB_SHORT_CODE 

SPOOL OFF 

QUIT 


 